
*** OPEN LOG/OUTPUT FILE ***

log using "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Output\cooperativeagreements.UQFE.SUPPLEMENTARY ANALYSIS #2.11-07-2020.smcl", replace





*** ALL COOPERATIVE AGREEMENTS [NEW AWARDS, CONTINUATION OF PREVIOUS AWARDS, & REVISIONS OF EXISTING AWARDS] ***


*** SUPPLEMENTARY ANALYSES INVOLVING BOTH AGENCY HEAD MANAGERIAL COMPETENCE & AGENCY STAFF TECHNICAL EXPERTISE CONDITIONAL EFFECTS BY PARTER ORGANIZATION TYPE [INCLUDING AGENCY HEAD POLICY EXPERTISE] *** 


**** ACCESS DATABASE ***

use "C:\Users\gk57526\Dropbox\Executive Particularism (Matt Zarit)\Cooperative Agreements\Empirics\OCTOBER 2020\Data\cooperativeagreements.grantlevel.MANUSCRIPT MODELS.11-06-2020.dta", replace



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************




*** OBTAIN DESCRIPTIVE STATISTICS FOR RELEVANT COVARIATES TO COMPUTE POSITIVE INTERQUARTILE UNIT CHANGE ///
*** IN MANAGERIAL COMPETENCE [zmanage2_abszero] & AGENCY STAFF TECHNICAL EXPERTISE [perc_tech] BASED ON EFFECTIVE SAMPLE [N = 241,730] ***

quietly xtrifreg fed_funding   zpolicy2_abszero  zmanage2_abszero ceo  privmgt  pctagency_packing perc_prof nongov_recip  ///
zloyalty2_abszero  electionyear unified pres_party house_majority any_chair house_app house_ways lnnewpop pctpoverty pcincomecd   action_a action_b ///
ln_l1_recip_grantamt ln_l2_recip_grantamt ln_l3_recip_grantamt   ///
year_89 year_90 year_91 year_92 year_93 year_94  year_95 year_96 year_97 year_98 year_99 year_00 year_01 year_02 year_03 year_04 year_05 year_06 year_07 year_08, ///
fe i(subagency) q(05)
*
*
*


*** EXAMINE YEAR TRENDS IN THE VOLUME OF CAs ACROSS ALL AGENCIES IN A GIVEN YEAR [NOTICE: INCREASING SECULAR TREND -- 'FLEXIBLY' CONTROL FOR IN OTHER MODELS USING YEAR FIXED EFFECTS] *** NOTE: FREQUENCY OF CAs RISE THROUGH TIME AS A POLICY ADMINISTRATIVE INSTRUMENT ***

tab year if e(sample)

*
*
*

*** AGENCY HEAD POLICY EXPERTISE OVER TIME: BIVARIATE LINEAR PREDICTION [AGGREGATE EFFECTIVE SAMPLE & DISAGGREGATED BY PARTNER RECEIPIENT ORGANIZATION TYPE] *** 

**** NOTE 1A: FOR TIME TO BE SPURIOUS IN THE RELATIONSHIP BETWEEN AGENCY HEAD EXPERTISE AND CA AWARD SIZE, EACH MUST BE UPWARD SLOPING THROUGH TIME ///
**** I.E., INCREASING AGENCY HEAD POLICY EXPERTISE THROUGH TIME IS SPURIOUSLY RELATED TO CA AWARD SIZE THROUGH TIME ***

**** NOTE 1B: THE EVIDENCE DOES NOT SUPPORT THIS TIME-SPURIOUS ALTERNATIVE EXPLANATION OF THE FINDINGS REPORTED IN THE MANUSCRIPT [SEE GRAPHS GENERATED BELOW] **** 


twoway  (lfitci zpolicy2_abszero year if e(sample)) 
*
*
twoway  (lfitci zpolicy2_abszero year if e(sample) & nongov_recip==0) 
*
twoway  (lfitci zpolicy2_abszero year if e(sample) & nongov_recip==1) 
*
*
twoway  (lfitci zpolicy2_abszero year if e(sample) & nonprofit_recip==1) 
*
twoway  (lfitci zpolicy2_abszero year if e(sample) & private_recip==1) 
*
*
*

*** notes on graphics code format for graphs made above. (1) Label Y-Axis "Agency Head Policy Expertise"; (2) Label X-Axis "Year"; (3) Y-Axis Range Set to +1.6 to +2.6 ///
*** (4) Title Heading "Figure SI-2A".... "Figure SI-2E [five graphs]; (5) Subtitle Heading "Full Sample", "Government Organizations", "Non-Government Organizations", ///
***     "Nonprofit Organizations", and "Private Organizations"; (6) Save each graphics file ***     


**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************

*** NATURAL LOGARITHM OF CA AWARD SIZE OVER TIME: BIVARIATE LINEAR PREDICTION [AGGREGATE EFFECTIVE SAMPLE & DISAGGREGATED BY PARTNER RECEIPIENT ORGANIZATION TYPE] *** 
*** Note: Natural Logarithm To Address Positive Skewness of these Data Across the Distribtion of the Dependent Variable (see Logged-OLS Conditional Mean Regressions Reported in ///
***       Analyses to Complement Quantile Regression Model Estimates)

twoway  (lfitci ln_fed_funding  year if e(sample))
*
*
twoway  (lfitci ln_fed_funding  year if e(sample) & nongov_recip==0)
*
twoway  (lfitci ln_fed_funding  year if e(sample) & nongov_recip==1)
*
*
twoway  (lfitci ln_fed_funding  year if e(sample) & nonprofit_recip==1)
*
twoway  (lfitci ln_fed_funding  year if e(sample) & private_recip==1)
*
*
*

*** notes on graphics code format for graphs made above. (1) Label Y-Axis "Natural Log of CA Award Size (in Dollars)"; (2) Label X-Axis "Year"; ///
*** (3) Y-Axis Range Set to +10.2 to +11.33; (4) Title Heading "Figure SI-2F".... "Figure SI-2J [five graphs]; (5) Subtitle Heading "Full Sample", "Government Organizations", ///
***     "Non-Government Organizations", "Nonprofit Organizations", and "Private Organizations"; (6) Save each graphics file ***     



**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************
**************************************************************************************************************************************************************************************


   
log close
